Notifications
Clear all
Topic starter 13/03/2020 10:31 pm
- I have typed =A8=M8 formula to compare 2 columns, these 2 columns are almost similar,
I got the results "True" and "False"
I want to highlight where all results of a formula is "False".
How-to go about it.
14/03/2020 9:49 pm
Hi @sumana,
to highlight the result of the values are false can be done by conditional formatting
follow the below steps
- Select the Column Range
- Go to Conditional Formating > New Rule
- A new window will open, from that select "Use a formula to determine which cells to format"
- Since conditional formating is accepting only value which TRUE, we need to change the logic of our comparison from FALSE to TRUE. there are other ways to do it, I like to do that simply use the NOT function to change the logic.
- Formula "=NOT(value1=value2)"
- Select the cell color
- OK
attached is the sample file for your reference.
Regards, Faraz Shaikh
Topic starter 20/03/2020 5:45 pm
Hi,
Thank you so much for your help, this "NOT" formula which you teach will definitely help me in time saving.
Once again thank you so much Faraz.
Kind regards,
Sumana
