highlight cell as answer

K

keith24

If I have an answer to an argument that exceeds a certain number then
want the cell to be colour flagged red as a warning so that it wil
instantly stand out in a large sheet of data. Any idea
 
R

Rob van Gelder

Conditional Formatting.

If the result of my formula in A1 is 5
And my Conditional Format for A1 is configured as:
Cell Value Is greater than 3
Colour Red
 
D

David McRitchie

Hi Keith,
Rob answered your question exactly as you asked for -- one cell.
I have a page on Conditional Formatting that you might want to
look at if you are interested in more than one cell.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Rob van Gelder said:
Conditional Formatting.

If the result of my formula in A1 is 5
And my Conditional Format for A1 is configured as:
Cell Value Is greater than 3
Colour Red
Click to expand...
 
Top