|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Equal Cells
Got it thank you,
--
thomp
"NBVC" wrote:
Select A3:B100 and invoke Conditional Formatting through Format menu.
Select Formula is from 1st drop down and enter formula:
=AND(A3=$A$2,B3=$B$2)
Click Format and choose your colour scheme
--
NBVC
Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122338
|