Conditional Formating

  • Thread starter Thread starter Albert Mulder
  • Start date Start date
A

Albert Mulder

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?
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CF (If Formula Is ) placed into macro 1
Excel Formula to add network file link to each month 1
get all cell address 1
#Value in FormulaArray 1
prob in IF then else statement 1
Junp start my Select Case Macro 12
Add to an Existing formula in a Cell using VBA 1
Using NULL in shading cells 1

Back
Top