I am looking to add an IF function in the conditional formatting as follows:
conditional formatting>new rule>use a formula to determine which cells to format
Can you add an IF statement to the 'format value where the formula is true' box, as below:
=IF(cell ref<0,"Reached Target","")
and format the function to make the On Target text green?
Bookmarks