Conditional format if other cells have any value is the same row.

[srizki]

Hi every one,

I have numbers and dates etc in columns A to G, I want to highlight the cells of that row from A – G of there are any numbers in columns H to AU.

Thanks

Sohail Rizki

 

[dave3009]

Perhaps you could try this

=NOT(ISERROR(LOOKUP(9.9999E+255, $H2:$AU2)))

Although I;m sure there is probably an easier option

 

[srizki]

Thanks Dave