ExcelBanter - Excel logical operator for a cell if another cell has a certain co

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel logical operator for a cell if another cell has a certain co (https://www.excelbanter.com/excel-programming/315996-excel-logical-operator-cell-if-another-cell-has-certain-co.html)

jerryhuyghe

Excel logical operator for a cell if another cell has a certain co

pseudo code:
=IF(BGCOLOROF(B14)="yellow","YES","")

duane[_34_]

Excel logical operator for a cell if another cell has a certain co

try this reference to get you going

http://www.xldynamic.com/source/xld.ColourCounter.htm

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=27592

All times are GMT +1. The time now is 11:51 PM.