ExcelBanter - Conditional formatting with IF function

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

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

- - Conditional formatting with IF function (https://www.excelbanter.com/excel-discussion-misc-queries/144317-conditional-formatting-if-function.html)

Michael

Conditional formatting with IF function

A B

Apple

sand

Conditional formatting with IF function

Hi Micheal

if you Want to aply conditional formating to column b ,Select range b2:b500
then go to Format- conditional FOrmating-Formula is =a2="apple"

and select format which you wants to apply

"Michael" wrote:

A B

Apple

All times are GMT +1. The time now is 07:05 AM.