im trying to get 2 conditional formats to run at once but cant seen to get it to work, i've set it up to do the following
condition 1 is set to cell value is - - equal to - - ="removed" format as pattern with a cross hatch patern selected
condition 2 is set to formula is - - =ifCU12<>""+CU12<cv12 - - format as font colour red
where cu 12 contains a date i've put in manually and cv 12 contains the formula =today()
the cell with the conditional format would be blank, contain a date or contain the word "removed" without the quotes
i can get either of them to work individually but not together
what am i doing wrong?
Bookmarks