Conditional Formatting If cell equal to ... format the whole row or column

[alexm]

Hello,

I need 2 conditional formatting rules:

1. if 1 cell value in row is let's say "xyz" format the whole cells in the row to be red (the text)

2. if 1 cell value in a column is "xyz" format the whole cells in the column to pe green (the cell fill).

Thank you very much

[Simon Lloyd]

Just select the whole row or column and apply your condition Like =countif(A1,"xyz")>0

[alexm]

Thx Simon but is not working, maybe i'm doing something wrong.

I've attached a file with an example.

I want the rows that have "Demis" in colomn C to automatically format as red text and the colums that have "Sam" and "Dum" to have the cell filled with any color (for example colum H has "Sam" in H3 and i want the cells filled from H3 to H283).

Thank you

[p45cal]

see attached

[Simon Lloyd]

Here's Demis and Sam sorted, you can work out how to do Dum :)