Hello..
I'm trying to get the conditional formatting to change the colour of the row in the selection. It works only on the first cell in the row & I can't figure out why.
Any ideas please?
Thanks
Hello..
I'm trying to get the conditional formatting to change the colour of the row in the selection. It works only on the first cell in the row & I can't figure out why.
Any ideas please?
Thanks
Change the conditional formatting rule formula to:
=AND($C1="BUY",$D1<$E1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks Jerry. I thought I'd tried everything
Cheers
Phil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks