Look at FormatConditional formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BranRow" wrote in message ...
| Hi, could you kindly assist me with highlighting a row that's programmed and
| meets your prefence. For eg:
|
| =IF(F8<=50, "Replenish","Sufficient")...I would prefer every replenish row
| to be highlighted red or whatever colour prefernce I have....
|
| need assistance
|
| tx