Hi all,
I'm not able to apply a simple rule based on index on another Colum. Here an example: Column A and B come with a series of values but I would like to amber column A based on values of Column B < 0
Hi all,
I'm not able to apply a simple rule based on index on another Colum. Here an example: Column A and B come with a series of values but I would like to amber column A based on values of Column B < 0
is that just the column next to a value thats < 0 regardless of value - or are you trying to match the value and only amber those that are the same ABS() value but negative
use a rule
highlight column A or a range A2:A100
=$B2<0
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks