conditional formatting for entire sheet

T

taco

hi there..

i hope someone will help me soon...
the problem is; data enter area is c6:ag138. if somebody will type one of S,
SH, SUS, NC datas, the color of entered data must be red. (font) how should i
create the formula in conditional formatting area for this application..

thanks for help.
 
A

Alex Delamain

Try this

In conditional format

set condition 1 to "formula is"

=IF(OR(A1="S",A1="sh",A1="sus",A1="nuc"),1,0)

set the format to red. then use the format painter to apply it to th
area required or the whole shee
 
B

Bob Phillips

Try

select C6:AG138
go to Format>Conditional Formatting
change the condition to Formul Is
add the formula
=OR(UPPER(A1)="S",UPPER(A1)="SH",UPPER(A1)="SUS",UPPER(A1)="NC")
click the Format button, and on the Font tab, set the font colour
OK out
 
D

David McRitchie

Most worksheet formulas, including these, are case insensitive,
so there is no need to convert lettercase for the comparison.
 
Top