ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Perplexed by simple Icon Set Cond. Formatting Issue (https://www.excelbanter.com/excel-worksheet-functions/449726-perplexed-simple-icon-set-cond-formatting-issue.html)

CJoQ

Perplexed by simple Icon Set Cond. Formatting Issue
 
1 Attachment(s)
Hi All,

I am absolutely perplexed as to why the attached jpeg showing conditional formatting rules and related data, does not work the way I expect it to.

I would expect
A1 = RED Circle (as it is 10)
A2 = UPWARD arrow (as it is < 10 and =5)
A3 = SIDEWAYS arrow (< 5)


However the conditional formatting does not seem to recognise that A2 is
< 10 and =5

How have I managed to mess this up?

Thanks Team,
CJoQ


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com