Hi all,
I'm having problems applying conditional formatting to a row of celss, each cell containg a formula similar to:
'=IF(b3<10, "0",IF(B3=10, "1"))'
Now I'm trying to format each cell in this row so that if a cell contains a "0" (as a result of its formula) then it should be red. If a cell contains a "1" (as a result of its formula) then it should be green.
The problem I have is that when I use conditional formating (format only cells that contain> cell value =...) - it doesn't work - presumably because the cell value isn't "0" or "1" but is instead the entire formula.
So I try using (format cells that contain>specific text =..). This works fine...until I save and then reopen the workbook - at which point all conditional formatting rules have been deleted and back to square one!
Can anyone point out what I'm doing wrong/what I can do to correct this?
Also - a similar/related problem - there is a macro in the workbook that takes data from the aforementioned row of cells and generates a pie chart. This worked fine when I manually input numbers into the cells (before I had the bright idea if using the 'IF' formulas to save me analysing an extract of data from another workbook and manually adding in the "0"'s ot the "1"'s). Now that I've implemented the 'IF' formulas into the relevant cells - the macro won't work - again: I'm guessing this is because it can't see/use the cells formula output value but instead just sees the formula. Any help?
Many thanks in advance if anyone can spare a thought.
Bookmarks