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
Â
