conditional formatting

  • Thread starter Thread starter David
  • Start date Start date
D

David

Using XL2000
I have a range of cells containing days of the week as text:
MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY
The text of each day name is 'centered across cells' with the cell to its
right. I would like both cells conditionally formatted in yellow pattern. I
can format one with 'Cell Value Is | equal to | =TEXT(TODAY(),"dddd")', but
I would like the adjacent cell formatted the same way.

I tried '=A1=TEXT(TODAY(),"dddd")' for B1, but got ugly results if I tested
by changing the system date, i.e. only part of the 2-cell range was
colored.

Is there a better way?
 
Select all cells across which you have centered the text. Assuming the text
itself is in A1, the formula to use in Conditional formatting is

=TEXT(TODAY(),"dddd")=$A1

note the dollar sign.
 
Myrna Larson wrote
=TEXT(TODAY(),"dddd")=$A1
Click to expand...

Tried it, but result was NO formatting.

Got this to work (note different cell references than original post)
J3 'Cell Value Is|equal to|=TEXT(NOW(),"dddd")
K3 'Formula Is|=J3=TEXT(NOW(),"dddd")

Then selected both cells, did a Copy, selected all the remaining cells and
did a Paste Special|Formats.
 
It works for me. You do have to use Formula Is, not Cell Value Is. The formula
shown below is what goes in the formula box. The cell reference is to the cell
containing the day of the week.
 
Myrna Larson wrote
It works for me. You do have to use Formula Is, not Cell Value Is. The
formula shown below is what goes in the formula box. The cell
reference is to the cell containing the day of the week.
Click to expand...

Noting that, I just tried again, adjusting to $J3 -- no joy :(

Maybe I'm not selecting right or something: selected J3:S3 and applied
'Formula Is|=TEXT(TODAY(), "dddd")=$J3'

Experimented, adjusting to J$3 and it sorta works, but it only formats the
first of the two cells for a given day.

What I finally ended up doing was separately merged J3:K3,L3:M3,M3:N3,
etc., then selected the five merged cells and applied:
Cell Value Is|equal to|=TEXT(NOW(),"dddd"), thus cutting down to a single
format.
Also works with Formula Is|equal to|TEXT(TODAY(),"dddd")=J$3 on those
merged cells.
 
Back
Top