Help! I have a worksheet cell that contains the formula =B26/C26. I want the value of that formula to appear in red if the value is greater and 1.00 (as a flag). I've tried to add an IF statement to the formula but nothing I try works.
Help! I have a worksheet cell that contains the formula =B26/C26. I want the value of that formula to appear in red if the value is greater and 1.00 (as a flag). I've tried to add an IF statement to the formula but nothing I try works.
Last edited by sgt.bsc; 07-02-2010 at 11:25 AM.
Select the cell(s) and go to Format>Conditional Formatting and set a value > 1 then set your formatting to red font (probably bold). Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks