LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 07, 05:35 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Jan 2007
Posts: 2
Default conditional Formatting based on cell formatting


I wanted to know if it was possible to do the following and if yes how.

I have a cell A1 (for example) that has a date (01/10/2006) which is
bold black. This is a deadline date therefore not the actual date. When
I get the actual date I change the formatting to bold Green/Red
(depending if I was on time or late). when the date is bold black, I
would like a conditional formatting to look at the date vs today and if
date < today then I would like to format the background of this cell

How can I do this ?

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 similar to shading alternating rows Conan Kelly Excel Worksheet Functions 10 August 22nd 06 11:13 PM
Cell Formatting Conditional On Other Cells Fill Color? [email protected] Excel Worksheet Functions 1 April 5th 06 10:05 PM
Conditional Formatting to Test Value in Cell Carroll Excel Worksheet Functions 3 March 9th 06 08:38 PM
Conditional Formatting Cell < Today() sagan Excel Worksheet Functions 3 September 21st 05 03:43 PM
Trying to add conditional formatting to every other cell...GOING . trixiebme Excel Worksheet Functions 2 March 24th 05 02:55 PM

All times are GMT +1. The time now is 07:46 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017