Hi All,
I'm trying to conditional format a range of cells that reference =Master!$B$6=0. This works as intended, but if I wanted to use format paint to easily add to another range of cells I need it to look like: =Master!$C$6=0
What is weird is if I do: =Master!B6=0 , not all cells within the range will format. I can't figure out why.
Can someone take a peek and let me know where I have gone wrong ?
Ron
This works:
=Master!$C$6=0
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Now if I want to use format paint to apply condition in Wednesday's range using D6=0 it doesn't do it automatically. I have to go into manage rules and adjust to d6.
ultimate goal is for the day to be shaded if there is no requirement for Overtime that day. So only days that require 1+ people will be shown
Is this possible ?
No, it won't do it automatically. The cells being referenced are in a contiguous horizontal row and you are expecting a non-contiguous vertical set-up to know which cell to use - that's not going to happen. Just set a rule for each day of the week - there are only seven days and once it's done, it's done.
True, but I'll have over 80 tabs :-(
Cumbersome, but I can poke away at it.
Seeing as you have the spreadsheet, would you mind looking at my vba code. It's set up to hide, unhide tabs based on if there is an OT requirement.
is there a better way to do the coding to reduce the number of lines? I've completed all the tabs for Mechanics, but I will have the same amount of sheets for Attendants and Body shop. This will make the VBA code extremely long. Wondering if there's a way to make what's there now, smaller or I can adjust the coding when I get the rest of the work completed.
Why not set up one tab with all the conditional formatting, then copy it?
If you want someone to look at your VBA, please start a new thread in the VBA section with a suitable title.
This thread needs marking as solved, please.
Sorry - I don't do VBA at all.
Why not set up one tab with all the conditional formatting, then copy it? - Not sure what your speaking about ? but sounds interesting ?
Thank You for your help. I will mark as solved.
You said you have 80 tabs. I am suggesting that you create one with all the condtional formatting set up and then copy it 79 times instead of setting conditional formatting individually on 79 more tabs. Is that clear?
Hmm, I think I have an idea what your saying. I'll give it a go.
Thanks
Sorry, I really don't know how to explain it any simpler.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks