Highlite cells C8 and D2. Select Format - Conditional Format - Formula Is
=$C$8 = 1. Change your format to red text and that should do it...
--
HTH...

Jim Thomlinson


"Albert Mulder" wrote:

I need a formula where if Cell (C8) =1 then Change that cell and another cell
to RED

IF (C8=1) then Cell (C8 & D2)=RED

What would the correct formula be?