During testing I changed data in cell A1 of attached Sheet. Please assume
A1=50 then text written in attached sheet will give true picture of my
query. In short, I want that if value in B1 is => A1 then conditional
format should make it ticked with OK, if B1<= A1 then ticked with sign !
otherwise with sign x. Main bottle neck is copy paste of this conditional
formatting from one cell to many other cells. Thanks for your help in
advance.
On Saturday, 8 February 2014 07:49:00 UTC+3, Zafar Iqbal wrote:
>
> Dear Experts,
>
> In Excel version 2007, I am trying to get conditional formatting with
> Icons. In this option targeted cell reference must be absolute like $A$1
> and it does not allow A1. Absolute reference becomes bottle neck for copy
> paste of this conditional formatting from one cell to others. I tried to
> use formula Indirect("A"&Row()) in conditional formatting dialog. It is
> strange for me that instead of linking to the same row it is checking data
> of one row below in the same column. When I checked the same formula in
> version 2010, it is working well. Sample file is attached. Please help in
> this matter and advise alternate options/formula to get Conditional
> Formatting with Icons and its copy paste to other bunch of many cells.
> Thanks
>
> Regards,
> ZAFAR IQBAL
> ---------------------------------------------------------------
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
