Conditional format text cells based on a column with numbers

Closed
oncearunner
Posts
1
Registration date
Wednesday July 17, 2013
Status
Member
Last seen
July 17, 2013
- Jul 17, 2013 at 05:10 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jul 18, 2013 at 11:11 AM
Hello,

So I have text cells describing what the numbers in the column next to it mean, however, I want the conditional formatting (data bars) to show up on the text cells, and not the percentage values in the column next to it. Any idea how to do this? Thanks in advance!!

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jul 18, 2013 at 11:11 AM
Hi Oncearunner,

Select the text cells (instead of the percentage value cells) before applying conditional format.

If this doesn't help, could you provide some sample data or maybe upload your file to a filesharing site (speedyshare, ge.tt etc...) for better understanding.

Best regards,
Trowa
0