pls.

[arsh]

i have in excel 5Rows & 5 Column

i 5th column if i type like ok / any thing, change the Red colour to
whole row, if nothing means it will be plain

how to use this in Conditional formating option / any

pls. give me example for that

thank you

 

[Bob Phillips]

Select all rows, assume start at row 1

In CF, change condition1 to Formula Is and add a formula of

=$E1="OK"

and set the pattern colour to red.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)