Dear Muneer,
You can also use below formula in conditonal formating.
=WEEKDAY($A11)=6
On Wed, Aug 15, 2012 at 7:46 PM, ashish koul wrote:
> use this formula in conditional format
>
> =AND(TEXT($A2,"ddd")="Fri")
>
>
> On Wed, Aug 15, 2012 at 12:09 PM, vijayajith VA
> wrote:
>
>> use ths below
use this formula in conditional format
=AND(TEXT($A2,"ddd")="Fri")
On Wed, Aug 15, 2012 at 12:09 PM, vijayajith VA wrote:
> use ths below code...
>
> .
>
> Sub highlight_friday()
> Dim rng As Range
> Dim cell As Range
> Dim sh As Worksheet
> Set rng = Sheet1.Range("A2:A" & Sheet1.Range("A" &
>
use ths below code...
.
Sub highlight_friday()
Dim rng As Range
Dim cell As Range
Dim sh As Worksheet
Set rng = Sheet1.Range("A2:A" & Sheet1.Range("A" &
Rows.Count).End(xlUp).Row)
For Each cell In rng
If VBA.Weekday(cell) = 6 Then
cell.Offset(0, 1).Interior.Color = vbCyan
End If
Next cell
End Sub
HI Muneer,,,
I think Few days back noorain & rajan had answered for same questions
On Wed, Aug 15, 2012 at 11:28 AM, Mohammed Muneer wrote:
> **
> Dear Group,
>
> Please highlight the text in column B based on Friday.
>
>
> Regards,
> Muneer,
> CC
>
> --
> Join official facebook page of thi
Dear Group,
Please highlight the text in column B based on Friday.
Regards,
Muneer,
CC
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread ti
