PDA

View Full Version : Conditional formatting again



austenr
08-09-2010, 01:12 PM
Can someone please tell me what is preventing my conditional formatting from not working. The formatting should remove the borders and turn the text white in the range "H23:K26" of the "Direct Bill Only" tab of the attached workbook if the value in that tab in D12 is = "X". It works for me in 07 but not in 03.

Artik
08-09-2010, 02:49 PM
In conditional formatting You have:
Formula is: ="$D$12=""X""" This is not a formula. This is the text. :)

Try it:
Formula is: =$D$12="X"

Artik

p45cal
08-09-2010, 02:55 PM
instead of
="$D$12=""X"""
use:
=$D$12="X"

I noticed that it didn't change until selectng another sheet and coming back to that one.

austenr
08-09-2010, 03:39 PM
Wonder why you don't see the changes til after you select another WS?