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

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