conditional formatting for entire sheet

[Guest]

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.

 

[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

 

[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

 

[David McRitchie]

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

 

[Guest]

thank you very much everyone for quick help.
problem solved.