ExcelBanter - conditional formatting

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - conditional formatting (https://www.excelbanter.com/excel-worksheet-functions/168046-conditional-formatting.html)

kami

conditional formatting

I want to apply conditional formatting to cell B4 or the range of cells as
yellow highlighted when the value of cell A1="Y"

I have tried formula is =if(A1="Y",) formatting yellow highlighted, but its
not working. Please help.

T. Valko

conditional formatting

Use Formula Is:

=$A$1="Y"

--
Biff
Microsoft Excel MVP

"kami" wrote in message
...
I want to apply conditional formatting to cell B4 or the range of cells as
yellow highlighted when the value of cell A1="Y"

I have tried formula is =if(A1="Y",) formatting yellow highlighted, but
its
not working. Please help.

All times are GMT +1. The time now is 09:00 AM.