when using a formula can I have certain values in red
 

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.

when using a formula can I have certain values in red
 

Use Data Validation with a formula that will evaluate to TRUE. Note the
formula should evaluate to TRUE *NOT* return TRUE eg.

=A1025

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"JD@Morrison" wrote in message
...
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.

when using a formula can I have certain values in red
 

formatconditional formatting

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JD@Morrison" wrote in message
...
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.

when using a formula can I have certain values in red
 

"Don Guillett" wrote in message
...
formatconditional formatting

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


Replace @mailinator.com with @tiscali.co.uk

when using a formula can I have certain values in red
 

My fingers do that also

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sandy Mann" wrote in message
...
"Don Guillett" wrote in message
...
formatconditional formatting

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


Replace @mailinator.com with @tiscali.co.uk