Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional format with a formula
I have done this before but for the life of me cannot remember how I did
it. Assume I have a column of dates. I want that column to be conditionally formatted so that today's date will be red for example. I enter =NOW()=1 in the formula for the conditional format but she no go. I tried TODAY (), etc too. Any ideas? TIA, R. |
#2
|
|||
|
|||
Mike tria only =now()
"Mike Echo" escreveu: I have done this before but for the life of me cannot remember how I did it. Assume I have a column of dates. I want that column to be conditionally formatted so that today's date will be red for example. I enter =NOW()=1 in the formula for the conditional format but she no go. I tried TODAY (), etc too. Any ideas? TIA, R. |
#3
|
|||
|
|||
Hi!
Try this..... Assume dates are in the range A1:A10 Select the range A1:A10 Goto FormatConditional Formatting Formula is: =A1=TODAY() Click the Format button and select the style you'd like OK out Biff "Mike Echo" wrote in message ... I have done this before but for the life of me cannot remember how I did it. Assume I have a column of dates. I want that column to be conditionally formatted so that today's date will be red for example. I enter =NOW()=1 in the formula for the conditional format but she no go. I tried TODAY (), etc too. Any ideas? TIA, R. |
#4
|
|||
|
|||
|
#6
|
|||
|
|||
Mike,
Don't know why you are comparing the date to 1 but you are correct it realising you need to force a True/False result. In this instance, you need to determine whether the cell has today's date it in, so select all of the cells, starting at A1 say, and use a formula of =A1=TODAY() -- HTH Bob Phillips "Mike Echo" wrote in message ... I have done this before but for the life of me cannot remember how I did it. Assume I have a column of dates. I want that column to be conditionally formatted so that today's date will be red for example. I enter =NOW()=1 in the formula for the conditional format but she no go. I tried TODAY (), etc too. Any ideas? TIA, R. |
#7
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Formula Needed | Excel Worksheet Functions | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
Conditional Format Question | Excel Worksheet Functions | |||
Conditional Format using value from another sheet | Excel Worksheet Functions | |||
Conditional Format | Excel Discussion (Misc queries) |