Conditional formatting

[divapaxo]

Hi All

Could someone please help me with a small problem i have
I would like to set up a conditional format so that in column "A"
everytime it sees the word "TOTAL" it will make the entire row
Red & Bold

could you please tell me what i need to write

thank you

 

[Andrew Poulsom]

With all the rows selected, Conditional Formatting Formula is:

=$A1="TOTAL"

which assumes that A1 is the active cell when it is entered. Change that reference to suit, but be sure to keep the $ before the column reference.

 

[Krishnakumar]

Select rows 1 to 10 or whatever the last row,

go to CF

Formula Is: =$A1="TOTAL"

change the format

HTH

 

[divapaxo]

thank you ever so much that is exactly what i needed to know