when using a formula can I have certain values in red

  • Thread starter Thread starter JD@Morrison
  • Start date Start date
J

JD@Morrison

I want to set an alert in my speadsheets if the number excededs a set value.
I have set the formular for true or false but would like it in red so I can't
miss it.
 
Use Data Validation with a formula that will evaluate to TRUE. Note the
formula should evaluate to TRUE *NOT* return TRUE eg.

=A10>25

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Don Guillett said:
format>conditional formatting
Click to expand...
Ah yes! That is just what I was thinking - it was just my fingers that got
it wrong <g>

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top