Hi all,
I'm trying to higlight and entire column based on the header of that column. For example, I have an if statement on the top cell of a column which will display either A or B. I'll like to have the entire column highligted if the header cell reads A.
hi Dinho05, welcome to the forum. i would not recommend highlighting the whole column. maybe assuming you need it for A2:A10, select just that range.
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$A$1="A"
then format to the colour you desire
if you want it highlighted if it's A OR B, then:
=OR($A$1="A",$A$1="B")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks for the response and you are right i'll rather have a range highlighted. Anyways, I highlighted the range and followed your suggestion but only the header cell was highlighted not the range
CF formula,select row(s)/column(s)
=A1=condition, then select the formatting, is a bludgeon, but does work, just make sure any additional formatting is checked"stop if true" to speed up processing...otherwise you could spend hours waiting for the conditional formatting to happen
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
I have attached a sample of the report. its a huge report so I simply copy and pasted part of it into a new workbook. As you will see the formula for highlighting isnt working.
PS: im aware that the formulas in the cells of the attachement arent working.
dredwolf can you explain that again. When I do the formatting nothig happens are you saying it is just taking too long to execute?
I was saying the method I suggested would be a resource hog, as it was being applied to complete rows and/or columns...
However, Looking at your sample, it looks like you have your condition Locked to A2($A$2) which is blank, so the condition is never met, Looks like you actually want it to reference B2, So Change the Formula for the range to =B$2="ACT", this should give you the Highlighting for the Range when the formulas are working
Hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks