Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello;
I browsed the previouse threads on this and didn't see what I needed, I have in column D cell 1 =now() for todays date, in row b thru h row 4 , I have the days of the week for a work flow. Both D1 and b4-h4 are formated usiing the date *3/14/2001 format. What I need to do is that on the day of the week I am working on I want that column to highlight a certain color. Example I tried in condittional formula was, formula is - =d1=b4 then choose my color. But this did not work..Any ideas..? I put this formula in cell b5 thru 16 and so forth........ Any help would be great. TY Lou |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting across a row, based on value in a single ce | Excel Discussion (Misc queries) | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
background formatting across multiple cells | Excel Discussion (Misc queries) |