ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting and OR (https://www.excelbanter.com/excel-discussion-misc-queries/223376-conditional-formatting.html)

Vanessa Simmonds

Conditional Formatting and OR
 
Good Evening,

How can use the formula OR in conditional formatting?

I want a cell to turn red if the value is either "A" or "B".

Is it possible?

Thank you very much.

Vanessa Simmonds

Elkar

Conditional Formatting and OR
 
Use this formula in your Conditional Format.

=OR(A1="A",A1="B")

HTH
Elkar


"Vanessa Simmonds" wrote:

Good Evening,

How can use the formula OR in conditional formatting?

I want a cell to turn red if the value is either "A" or "B".

Is it possible?

Thank you very much.

Vanessa Simmonds



All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com