ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Formatting Intermittent at best (https://www.excelbanter.com/excel-worksheet-functions/26322-conditional-formatting-intermittent-best.html)

Yogi_Bear_79

Conditional Formatting Intermittent at best
 
I have a column in my spreadsheet tht uses conditional formatting. Each cell
in the column is idnetical in it's setup. The conditional formatting only
seems to work on about 75% of the cells.Any idea on how to force it to work
on all of them properly?

CONDITION 1
=(IF(ISERROR(DATEDIF(H10,NOW(),"d")),0,(DATEDIF(H1 0,NOW(),"d")))0)

Make the text RED

CONDITION 2
If the date is between =NOW()+60 and = NOW()+31
Make the text green

CONDITION 3
If the date is between = NOW()+30 and =NOW()+1 Make the text Orange




Hi

Don't forget that the CF runs in the order that the conditions are input.
This means as soon as one of the conditions is met, the rest will be
ignored.

--
Andy.


"Yogi_Bear_79" wrote in message
...
I have a column in my spreadsheet tht uses conditional formatting. Each
cell
in the column is idnetical in it's setup. The conditional formatting only
seems to work on about 75% of the cells.Any idea on how to force it to
work
on all of them properly?

CONDITION 1
=(IF(ISERROR(DATEDIF(H10,NOW(),"d")),0,(DATEDIF(H1 0,NOW(),"d")))0)

Make the text RED

CONDITION 2
If the date is between =NOW()+60 and = NOW()+31
Make the text green

CONDITION 3
If the date is between = NOW()+30 and =NOW()+1 Make the text Orange






All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com