I want to apply a conditional format to a cell on my workbook which will make the cell blue in the following circumstances a) the cell is displaying no data and b) a certain cell elsewhere on my worksheet does not contain the text "VC" or "NV".
The problem is that the cell I want to apply this conditional formatting to also contains a formula which automatically populates the cell if a certain cell elsewhere on my worksheet contains the text "VC".
When I set up my formula within the conditional formatting window it does not work because I think it detects the formula within the active cell and therefore does not regard the cell as not displaying any data.
The conditional formulas I have been trying to use are;
Condition 1
=IF(OR(I18="VC",I18="NV"),"TRUE","FALSE") and
Condition 2
=IF(J18<1,"True","False")
The default cell colour is currently blue and I have set the conditional formatting so that when the conditions of the formula above is true it changes to white.
Is it possible to do what I am trying to do whilst the formula to prepopulate the active cell is in place.
Apologies if this is not clear but this is my first post to a forum of this type. If you need any clarification please get in touch.
Thank you.
Bookmarks