• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel 2010: Reference other cells when using icons sets (conditional formatting)?

RichUK

RichUK

Lifer
For example: I want to use the traffic light icon set (conditional formating) in B1 and reference a percentage in A1.

Any suggestions. The basic formulas I use do not work...
 
KLin said:
Why not use the conditional formatting to format the cell red, green or yellow?
Click to expand...

You're right, I could do, but it doesn't look as good.

I've managed to adjust the presentation of my tracker to accommodate for this constraint, so all is not lost. It just means using two cells instead of 1.

Pretty lame limitation by MS, if you ask me.
 
Defnitely not WMK if you're trying to use a stupid signal light in an excel spreadsheet.

😛
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top