Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-19-2011, 07:22 AM
Posts: n/a
Default Conditional Formatting

I am using columns B through H. When column F contains "yes" that cell formats in blue. When column G contains "yes" it formats in pink. When column H contains "yes" it formats in yellow.

All of the cells in that row, B through H, need to format yellow whenever column H contains, "yes." If Column H does NOT contain "yes," I would like column F to remain blue, and column G to remain pink.

I am getting really strange results. If I use =H3="yes" and apply it to =$B$3:$H$77, only F, G and H format in yellow, even though the other columns are within that range. Furthermore, I lose the blue and pink formatting in rows that have no "yes" in column H because everything turns yellow.

I tried various other ranges , or popped the conditional formatting into different cells, and found random cells displaying in yellow - sometimes these cells wouldn't even be in the same row as H="yes". However, I could never get the entire row to turn yellow no matter what I did.

The only other conditional formatting applies gray formatting to blank cells. Only columns E through H would ever be blank, so I used range =$E$3:$H$77. I don't know if conflicting conditional formatting is causing this, or if I just don't understand how to apply it. Can you please advise?

Reply With Quote
Old 08-19-2011, 07:48 AM
Kimberly Kimberly is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road

To fix conflicting conditional formats, Conditional Formatting > manage Rules. Select a rule and use the Move Up or Move Down button to change the order that the rules are enforced. The top rule will override the others.
Reply With Quote
Old 08-20-2011, 12:06 AM
Catalin.B Catalin.B is offline Conditional Formatting Windows Vista Conditional Formatting Office 2007
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road

Another frequent error is about using "$". Focus on understanding this issue, and your problem is solved

if you use this formula, =H3="yes" , and you want that all columns in this row to depend on column H, you have to lock the column in your formula, otherwise , excel will evaluate the next column formula as : =I3="yes", the next column as =J3="yes", and so on.
Try: =$H3="yes", and excel will evaluate all columns involved in your range depending only for the value in column H.
Reply With Quote
Old 08-25-2011, 01:46 PM
Posts: n/a

That was perfect! Thank you!
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM
Conditional Formatting * Conditional Formatting MS 2010 djreyrey Excel 3 06-03-2011 01:54 AM
Conditional formatting of Today +21 days? SHERMAN Excel 3 12-20-2010 08:08 AM
Challenge!! Need help though. (Conditional formatting) knuckles70 Excel 2 02-05-2010 12:24 PM
Conditional Formatting to Hide Rows or Columns? sczegus Excel 0 09-26-2006 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:15 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd. is not affiliated with Microsoft