Forum

Notifications
Clear all

Conditional Formatting

5 Posts
3 Users
0 Reactions
66 Views
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

I need some help with conditional formatting.  When "Yes" appear in Row 5, cells in column AK are to be highlighted according to appropriate color box.

There could be several boxes highlighted in column AK. 

 
Posted : 01/03/2019 3:07 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Melinda

Give this a try

 
Posted : 01/03/2019 8:52 pm
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Melinda,

This might help you with CF

https://www.myonlinetraininghub.com/how-to-use-excel-conditional-formatting

Regards

Phil

 
Posted : 01/03/2019 9:35 pm
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

Sunny and Phil

To both of you. THANK YOU so very much!  Seeing the actual formula on the spreadsheet that Sunny provided helped me to understand it better. Then the link sent by Phil helped me to figure out the next step. 

 
Posted : 02/03/2019 12:33 pm
(@sunnykow)
Posts: 1417
Noble Member
 

No problem.

Glad we are able to help.

 
Posted : 02/03/2019 7:03 pm
Share: