Conditional Formatting

  • Thread starter Christine Wilso
  • Start date
C

Christine Wilso

How do you get text in cell A1 to appear in a bold font if a dat
appears in cell B1?
Can this be done in conditional formatting, if so, how
 
A

AlfD

Hi!

The following will recognise a _value_ in B1 and make A1 bol
accordingly.

Select A1 and click Format > Conditional Formatting.
Choose Formula is (instead of Cell value is) and put in the bo
=$B$1<>"" . This says B2 is not empty.
Click Format... and choose Bold. OK. OK.

A date is just a number with a particular format. If your need is t
spot an entry (rather than a blank) in col B, the above will work.
If your need is to spot a date rather than some other kind of entry
I'd need to know what other sorts of data were in col B.

Al
 
D

David McRitchie

If by any chance you do need to try to distinguish a date.
There is no specific test for a date, but you can check that the
number falls within a range: i.e. 36161 and 73051
or use Date in following manner

=AND(A1>DATE(1999,1,1),A1<DATE(2100,1,1))
 
Top