Thread: EXcel problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MicrosoftBob MicrosoftBob is offline
external usenet poster
 
Posts: 1
Default EXcel problem

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