Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 07, 04:36 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

Hello,

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
RED.

How can I do this ?
Thanks


  #2   Report Post  
Old January 15th 07, 06:01 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 1
Default PLEASE HELP!

I am working on a worksheet that is all dates. I have 5 things(dates) that
need to happen in order for me to to count it as 1. How do I set up a
function to say that...and if there is not date not to count it?

PLEASE HELP ME!!!


  #3   Report Post  
Old January 15th 07, 06:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,718
Default PLEASE HELP!

=SUMPRODUCT(--ISNUMBER(A1:A100))

adjust to suit


"MsSealy" wrote:

I am working on a worksheet that is all dates. I have 5 things(dates) that
need to happen in order for me to to count it as 1. How do I set up a
function to say that...and if there is not date not to count it?

PLEASE HELP ME!!!


  #4   Report Post  
Old January 20th 07, 02:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 5
Default conditional Formatting based on cell formatting

Hi,

Try

=A1TODAY()

See link for instruction on conditional formatting

http://www.contextures.com/xlCondFormat01.html

VBA Noob

Totom wrote:
Hello,

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
RED.

How can I do this ?
Thanks




Reply
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
Conditional formatting formula that uses VLookup, based on content of another cell Fred Excel Discussion (Misc queries) 2 August 3rd 06 10:38 AM
Cell Formatting Conditional On Other Cells Fill Color? [email protected] Excel Worksheet Functions 1 April 5th 06 10:05 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 01:55 PM


All times are GMT +1. The time now is 10:02 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017