Trouble with conditional formatting with formulas

willow1985

Well-known Member
Joined
Jul 24, 2019
Messages
736
Office Version
  1. 365
Platform
  1. Windows
I always seem to have trouble with conditional formatting.
Here are the formatting rules I have created:

1575471754728.png


What I need is as follows:

=$F2:$F1000="Y" If column F has the text "Y" in it then the entire row (from A:N) should format the text to green
=AND($F2:$F1000="N",$F2:$F1000<>"") If column F has the text "N" AND the cell beside it in Column E is not blank it should format the text to blue

The only one that seems to work is the =$E2:$E1000="" then format the font Red.
The other 2 seem to only affect column E for some reason and only work some of the time. I just cant figure it out.

Any help would be appreciated, this is probably one of the functions of excel I dread working with....

Thank you

Carla
 

willow1985

Well-known Member
Joined
Jul 24, 2019
Messages
736
Office Version
  1. 365
Platform
  1. Windows
Guess so, never thought to scroll down and then back up but it definitely had me puzzled 😅
IT was in my pc this morning so perhaps that is how my automatic calculation got turned off but either way I added a VBA code to turn it on when the book is opened.

Thank you again! 😊
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
63,645
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,143,677
Messages
5,720,259
Members
422,273
Latest member
linds75

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top