If, Then

analis_yeg
New Contributor

I am not sure what I am doing incorrectly when trying to do conditional formatting:

I have tried with full columns as well as individual cells. My formula looks like this: =$E:$E=”Yes”
format grey
applies to =$F:$F


I then go to my document and choose Yes from the pull down menu and it does not change any cells.

 

Please advise

 

Thank you for your time!

 

A

3 Replies

Hello @analis_yeg,

 

Assuming your data starts at cell E1:

Set your formula to =E1="Yes" and apply it to $F:$F.

 

This should fix your issue.

Here is what my formula looks like when I go under conditional formatting:

=$E:$E="Yes"

format grey

applies to: =$F:$F

 

When I apply this, nothing happens. Same if I just choose 2 cells as opposed to 2 columns...

If you set your formula as =$E:$E=“Yes”, then you will return nothing because the entire column E does not equate to “Yes”.

Instead, in only the first cell of which you would like to apply the conditional formatting (i.e. cell F1), set the conditional format formula to =E1=“Yes”. Then in the “applies to” section, select F:F. This will allow the conditional format to search in each adjacent cell for the text “Yes”.

For example, if cell E1 holds the value “Yes”, then cell F1 will be formatted grey. If the cell E2 holds the value “No”, then cell F2 will not be formatted grey.

I hope this helps!
PReagan

*This post was sent via mobile so please excuse any typos
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies