ExcelBanter - conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/220612-conditional-formatting.html)

Sharon

conditional formatting

On conditional formatting for dates, say I need dates between 1/1/09-4/30/09
to turn red. Can this be done?

muddan madhu

conditional formatting

condition 1 : formula is :

=AND(A1=DATE(2009,1,1),A1<=DATE(2009,4,30))

On Feb 12, 11:12*pm, Sharon wrote:
On conditional formatting *for dates, say I need dates between 1/1/09-4/30/09
to turn red. Can this be done?

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