LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default fill a cell color using date in one cell and "yes/no" in another c

I want to use two different cells in a single row (one a date-formatted cell
& one a "Yes/No" text value cell) to display a cell fill color in a third
cell - based on the conditions (e.g., date is <= today and text is "no" -
filling third cell with red) present;

How can I do this?

Txs!
 
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
Incorporating Cell color fill in an "if" logical function? George_Sky Excel Worksheet Functions 46 April 4th 23 02:18 PM
How do I change the fill color of a cell using an "IF" function donschap Excel Worksheet Functions 6 March 9th 10 03:48 PM
How to change text color in a cell "comment" in Office 2007? conductor Excel Worksheet Functions 1 June 2nd 07 02:50 AM
Excel needs multiple "Fill color" buttons for faster coloring. SC0718 Setting up and Configuration of Excel 1 May 23rd 07 01:37 PM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM


All times are GMT +1. The time now is 12:44 AM.

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

About Us

"It's about Microsoft Excel"