Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I setup the following formula in conditional formatting to turn the cell
yellow if the amount listed in cell B25 is not found in column T. I then also added the beginning part of the formula to not turn yellow if the date listed in cell A1 is a day in the futu =0=IF(A1=TODAY(),1,IF(ISNA(VLOOKUP(B25,T2:T1500,1 ,0)),0,1)) I want to add one more condition to the forumla that says if the amount listed in cell B25 is 0, don't turn the cell yellow. How can I tweak the formula listed above? Right now the cell is turning yellow because a 0 is in cell B25, but not found in column T. Any help would be appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |