highlight cell as answer

  • Thread starter Thread starter keith24
  • Start date Start date
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
 
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
 
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


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...
 
Back
Top