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 Contributor Last seen December 27, 2022 - Jun 16, 2014 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jun 16, 2014 at 11:26 AM
Related:
- Conditional Formatting Special
- Facebook special characters - Guide
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Formatting windows 7 - Guide
- Using special characters in word - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Jun 12, 2014 at 11:27 AM
Jun 12, 2014 at 11:27 AM
Hi IneedHelp,
Try removing the $ symbols and drag B4 to V4 applying format only.
Best regards,
Trowa
Try removing the $ symbols and drag B4 to V4 applying format only.
Best regards,
Trowa
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.
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
Contributor
Last seen
December 27, 2022
555
Jun 16, 2014 at 11:26 AM
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
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
