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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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.
Related:

2 responses

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

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

Best regards,
Trowa
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.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response