Conditional Formatting with IF

[aarti_rto]

Hello Experts,

I need help in highlight the cells of "Doc Reference ID" by referring "GST%".

Requirement is - IF "GST %" column is not equal to 18 OR 28 then respective cell of "Doc Reference ID" should highlight in RED

Doc. Reference ID	GST %
202100004415	18
202100004437	28
202100004438	28
202100004439	28
202100004419	18.8
202100004434	18.2
202100004434	28.2

 

[mart37]

=AND($B2<>18;$B2<>28)

 

[aarti_rto]

=AND($B2<>18;$B2<>28)

can you elaborate it , i'm not getting desired output..

 

[jtakw]

Hi,

It may just be a regional thing, try changing the semicolon to a comma:

=AND(B2<>18,B2<>28)

Use this for CF formula in your Doc. Reference ID column, Change B2 to reference your first cell in your GST % column.