Good Afternoon,
I would like your help with a conditional formatting problem I have, Basically in A1:A4 I have the following conditions Apple,Pear,Orange,Grapes. If any of these are matched within column D of my table (B10:E40) then I need the entire row (Not just the containing cell) formatting Bold?
Block select your range to format.
Set conditional format formula to: =D10=$A$1:$A$4
Select your bold format for that being true.
=COUNTIF($A$1:$A$4,$D10)>0
for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting
Highlight applicable range >>
B10:E40
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=COUNTIF($A$1:$A$4,$D10)>0
Format [Number, Font, Border, Fill] - BOLD FONT
choose the format you would like to apply when the condition is true
OK >> OK
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks