Excel if then bold

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bernie - 18 Mar 2008 22:10 GMT

I would like to set up an expression where if the today's date (listed in
column A) is greater than the dater listed in column B, the date in column A
bolds.
Help is appreciated!

Reply to this Message

David Biddulph - 18 Mar 2008 22:18 GMT

In A2, Format/ Conditional Formatting/ Cell Value Is/ Greater than/ =B2 ,
and set the format to Bold
--
David Biddulph

>I would like to set up an expression where if the today's date (listed in
> column A) is greater than the dater listed in column B, the date in column
> A
> bolds.
> Help is appreciated!

Reply to this Message

John - 18 Mar 2008 22:25 GMT

(in excel 2003) Select cell A1 and got to Format>conditional format and set
"cell value is greater than B1" and set the format you want

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> I would like to set up an expression where if the today's date (listed in
> column A) is greater than the dater listed in column B, the date in column A
> bolds.
> Help is appreciated!

Reply to this Message