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/97564-conditional-formatting.html)

Tufail

Conditional Formatting

hi,
i am trying to use CF if A1 has date then want change background color of B1
but it doesn't work.

=hasdate(a1)

thanks in advance.

excelent

Conditional Formatting

try:
=CELL("format";A1)="D1"

"Tufail" skrev:

hi,
i am trying to use CF if A1 has date then want change background color of B1
but it doesn't work.

=hasdate(a1)

thanks in advance.

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