LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Louis Markowski
 
Posts: n/a
Default Conditional Formatting Multiple cells based on 2 cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting greg Excel Discussion (Misc queries) 1 March 24th 05 10:13 PM
conditional formatting across a row, based on value in a single ce oaode Excel Discussion (Misc queries) 1 March 14th 05 04:19 PM
counting cells with conditional formatting applied HalB Excel Discussion (Misc queries) 3 February 21st 05 01:21 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 2nd 04 11:04 PM
background formatting across multiple cells Casper Excel Discussion (Misc queries) 0 November 26th 04 11:18 AM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"