RE: Conditional Formating

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jim Thomlinson <James_Thomlinson@xxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 15 May 2008 12:43:01 -0700

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?

References:
- Conditional Formating
  - From: Albert Mulder

Prev by Date: Re: code to SAVE
Next by Date: Re: can .range return a 1D array?
Previous by thread: Conditional Formating
Next by thread: Conditional Formating
Index(es):
- Date
- Thread