Conditional format text cells based on a column with numbers

Closed
Report
Posts
1
Registration date
Wednesday July 17, 2013
Status
Member
Last seen
July 17, 2013
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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