M
MicrosoftBob
As an example I have a estimated monetary value in cell B4 and in cell C4 I
have the actual cost. I have set up the spreadsheet to show in cell F4:- if
the value is lower in cell C4 then the text in cell F4 is set to 'OK' if the
value is higher then the text is set to 'over budget. I wish to change the
text colour in F4 to red if the item is 'Over Budget' and blue if a returned
value is OK.
Thank you for any help
Bob
have the actual cost. I have set up the spreadsheet to show in cell F4:- if
the value is lower in cell C4 then the text in cell F4 is set to 'OK' if the
value is higher then the text is set to 'over budget. I wish to change the
text colour in F4 to red if the item is 'Over Budget' and blue if a returned
value is OK.
Thank you for any help
Bob