Previous Topic Next Topic

Conditional Formatting Special

Closed
IneedHelp2015
Posts
1
Registration date
Tuesday May 27, 2014
Status
Member
Last seen
May 27, 2014
 - May 27, 2014 at 11:40 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 - Jun 16, 2014 at 11:26 AM
Hi,
I'm trying to create a conditional formatting to highlight the column if the cell in row 4 ="S".
I can do it one column at the time, like the rule: =$B$4="S" applies to =$B:$B.
I would like to create the rule to Active column row 4="S" and then apply to for example $B$V.
I hope it makes sense.
Please help me.

2 replies

Answer 1 / 2
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 509
Jun 12, 2014 at 11:27 AM
Hi IneedHelp,

Try removing the $ symbols and drag B4 to V4 applying format only.

Best regards,
Trowa
0
Answer 2 / 2
IneedHelp2015
Jun 13, 2014 at 09:41 AM
Hi,
That doesn't work.
At the moment I have "Fromat values where this formula is true:" =IF(INDEX(4:4,COLUMN())="S",1,0)=1. It applies to: =$B:$L
It applies the formatting in the correct coulms but applies the formatting only in the first row instead of the whole column.
I need the whole column to be formatted not the first row only.
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 509
Jun 16, 2014 at 11:26 AM
That is because I'm working with Excel 2003 and you clearly have a newer version.

We can try the following:
You upload your file (careful with personal info) to a file sharing site like www.speedyshare.com or ge.tt and post back the download link.
I will apply the conditional format and then you can see how it looks.

Best regards,
Trowa
0