Forum Discussion
Conditional Formatting to Highlight Cells Based on Yes/No Values
All you need is, select the range in column A:G say A2:G100 and make two New Rules for conditional formatting using the formulas given below.
For Yes (Green):
=$F2="Yes"
and set the format as per your choice.
For No (Red):
=$F2="No"
and set the format as per your choice.
In the attached I selected the range A2:G100 and make two New Rules for conditional formatting using the above formulas.
Please refer to the attached for more details.
Subodh_Tiwari_sktneer Thank you for answering with that very simple solution! I tried to do it without selecting the whole range the document will be using and it didn't work so I selected the range of cells to be included in the document and plugged in the formulae and it worked perfectly. Thank you again!
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the solution provided as a Best Response to mark your question as Solved.
Hi Subodh_Tiwari_sktneer
I found the above very helpful and having an issue whereby I wish to remove the $ from the applies to element so the rule can apply independently each time.
ie: in cell A1, when AA1 = Yes, 'do this'... when AA1 = No, 'do that'... then B1, when AB1 = Yes, 'do this'... when AB1 = No, 'do that'
Then I am looking to fill down to copy the conditioning across multiple rows, however due to the $ (absolute) reference, its not allowing this to be achieved. Do you have any tips or tricks to work around this?Here is a screenshot to try and outline what I am trying to do.
I want to conditionally format each cell to its aligned Yes/No on the right.
The desired outcome would be to then accomodate for the conditioning and logic to apply to each subsequent row below it, referencing the corresponding cells in the same row.
