Windows 10: Conditional formatting problem

I need conditional formatting to compare 2 lists of numbers with the goal of formatting numbers not in the second list. The first list has 300 numbers; the second list has 2000 numbers. Here is a formula I've tried unsuccessfully. It formats all 300 numbers in the first list even though they do appear in the second list. =COUNTIF$AP$3:AP$2000,AE300=0 Same with this formula=COUNTIF$AP$3:AP$2000,AA300=0Any help you can give me will be greatly appreciated. Thank youGwen

:)

 

Conditional Formatting

Hi J,

I am Dave, I will help you with this.

If you select the first revised ship date cell and select Conditional Formatting - Highlight Rules - Greater than and then click the corresponding estimated shipping date cell, that should set the conditional formatting for that cell.

Then to apply that rule to all other cells in that column, select that cell, then click 'Format Painter' and click the cell below that cell and drag down to fill the column with the same conditional formatting rule.

 

How To Format A Write Protected Flash Memory ?

¿You already tried this one?...

Run CMD


1. diskpart
2. list disk

Then in the 3º step, put the correct number of disk in the list for the usb flash (if it's listed in disk 3, then you'll have to write select disk 3).

2. select disk #
3. clean
4. create partition primary
5. select partition 1
6. active
7. format fs=fat32
8. assign
9. exit

with that commands you will format the flash drive in fat32, if you have a large drive you can select also "format fs=ntfs" in step 7.

good luck!

 

Conditional formating

Okay,, the example is just a small sample of my data.
Lie I said , I want a cell that is an L to have a red fill if the cell below is > 8.
The cell contents can change and that is why I need to use conditional formatting.
But I need help on how to do it.
You can find the conditional formatting icon in the Home tab at the top.
Len